Tabela Referral

Definicja tabeli Referral

Name

Referral

Code

Referral

Comment

 


Lista kolumn tabeli Referral

Name

Code

ReferralID

ReferralID

PersonnelTypeID

PersonnelTypeID

ICDID

ICDID

ContractorID

ContractorID

ID

ID

Date

Date

OrgUnitType

OrgUnitType

OrgUnitID

OrgUnitID

OrgUnitStatCode

OrgUnitStatCode

PersonnelNPWZ

PersonnelNPWZ

Institution

Institution

Type

Type

RescueNo

RescueNo

OrdinalNumber

OrdinalNumber

IcdCode

IcdCode

OrgUnitStatCode8

OrgUnitStatCode8

ContractorType

ContractorType

PersonnelPesel

PersonnelPesel

UnitsCount

UnitsCount

LimitIssuePeriodStartDT

LimitIssuePeriodStartDT

ArticleIssuePeriod

ArticleIssuePeriod

EDocRoot

EDocRoot

EDocIdent

EDocIdent


Kolumna ReferralID tabeli Referral

Definicja kolumny ReferralID tabeli Referral

Name

ReferralID

Code

ReferralID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonnelTypeID tabeli Referral

Definicja kolumny PersonnelTypeID tabeli Referral

Name

PersonnelTypeID

Code

PersonnelTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ICDID tabeli Referral

Definicja kolumny ICDID tabeli Referral

Name

ICDID

Code

ICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractorID tabeli Referral

Definicja kolumny ContractorID tabeli Referral

Name

ContractorID

Code

ContractorID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ID tabeli Referral

Definicja kolumny ID tabeli Referral

Name

ID

Code

ID

Data Type

VARCHAR2(30)

Mandatory

No

Comment

 


Kolumna Date tabeli Referral

Definicja kolumny Date tabeli Referral

Name

Date

Code

Date

Data Type

DATE

Mandatory

No

Comment

 


Kolumna OrgUnitType tabeli Referral

Definicja kolumny OrgUnitType tabeli Referral

Name

OrgUnitType

Code

OrgUnitType

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna OrgUnitID tabeli Referral

Definicja kolumny OrgUnitID tabeli Referral

Name

OrgUnitID

Code

OrgUnitID

Data Type

VARCHAR2(14)

Mandatory

No

Comment

 


Kolumna OrgUnitStatCode tabeli Referral

Definicja kolumny OrgUnitStatCode tabeli Referral

Name

OrgUnitStatCode

Code

OrgUnitStatCode

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna PersonnelNPWZ tabeli Referral

Definicja kolumny PersonnelNPWZ tabeli Referral

Name

PersonnelNPWZ

Code

PersonnelNPWZ

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Institution tabeli Referral

Definicja kolumny Institution tabeli Referral

Name

Institution

Code

Institution

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna Type tabeli Referral

Definicja kolumny Type tabeli Referral

Name

Type

Code

Type

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna RescueNo tabeli Referral

Definicja kolumny RescueNo tabeli Referral

Name

RescueNo

Code

RescueNo

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna OrdinalNumber tabeli Referral

Definicja kolumny OrdinalNumber tabeli Referral

Name

OrdinalNumber

Code

OrdinalNumber

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna IcdCode tabeli Referral

Definicja kolumny IcdCode tabeli Referral

Name

IcdCode

Code

IcdCode

Data Type

VARCHAR2(8)

Mandatory

No

Comment

 


Kolumna OrgUnitStatCode8 tabeli Referral

Definicja kolumny OrgUnitStatCode8 tabeli Referral

Name

OrgUnitStatCode8

Code

OrgUnitStatCode8

Data Type

VARCHAR2(4)

Mandatory

No

Comment

VIII czesc kodu resortowego jednostki zlecajacej ze skierowania


Kolumna ContractorType tabeli Referral

Definicja kolumny ContractorType tabeli Referral

Name

ContractorType

Code

ContractorType

Data Type

VARCHAR2(2)

Mandatory

No

Comment

Typ swiadczeniodawcy, który wystawil zlecenie


Kolumna PersonnelPesel tabeli Referral

Definicja kolumny PersonnelPesel tabeli Referral

Name

PersonnelPesel

Code

PersonnelPesel

Data Type

VARCHAR2(11)

Mandatory

No

Comment

Pesel osoby kierujacej wykonaniem procedury


Kolumna UnitsCount tabeli Referral

Definicja kolumny UnitsCount tabeli Referral

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(16,4)

Mandatory

No

Comment

Ilosc wyrobu medycznego zleconej przez osobe uprawniona


Kolumna LimitIssuePeriodStartDT tabeli Referral

Definicja kolumny LimitIssuePeriodStartDT tabeli Referral

Name

LimitIssuePeriodStartDT

Code

LimitIssuePeriodStartDT

Data Type

DATE

Mandatory

No

Comment

Poczatek okresu na który zlecono zaopatrzenie


Kolumna ArticleIssuePeriod tabeli Referral

Definicja kolumny ArticleIssuePeriod tabeli Referral

Name

ArticleIssuePeriod

Code

ArticleIssuePeriod

Data Type

NUMBER(10)

Mandatory

No

Comment

Dlugosc okresu na który zlecono zaopatrzenie


Kolumna EDocRoot tabeli Referral

Definicja kolumny EDocRoot tabeli Referral

Name

EDocRoot

Code

EDocRoot

Data Type

VARCHAR2(60)

Mandatory

No

Comment

Identyfikator e-skierowania - czesc 1


Kolumna EDocIdent tabeli Referral

Definicja kolumny EDocIdent tabeli Referral

Name

EDocIdent

Code

EDocIdent

Data Type

VARCHAR2(22)

Mandatory

No

Comment

Identyfikator e-skierowania - czesc 2


Lista kluczy tabeli Referral

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Referral

Definicja klucza Identifier_1 tabeli Referral

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment